/****************************************************************************
SQL Script (Microsoft SQL Server)

Created with: SQL Offline 1.0.0.4

Agent: OleDb
Connection: Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=flask;Data Source=.\sqlexpress
Table: Products
****************************************************************************/

CREATE TABLE [Products] ([ProductID] int IDENTITY NOT NULL, [ProductName] nvarchar(40) NOT NULL, [SupplierID] int NULL, [CategoryID] int NULL, [QuantityPerUnit] nvarchar(20) NULL, [UnitPrice] smallmoney DEFAULT '0', [UnitsInStock] smallint DEFAULT '0', [UnitsOnOrder] smallint DEFAULT '0', [ReorderLevel] smallint DEFAULT '0', [Discontinued] bit DEFAULT '=No')
ALTER TABLE [Products] ADD PRIMARY KEY ([ProductID])
CREATE INDEX [ProductName] ON [Products] ([ProductName])
CREATE INDEX [SupplierID] ON [Products] ([SupplierID])
CREATE INDEX [SuppliersProducts] ON [Products] ([SupplierID])
CREATE INDEX [CategoriesProducts] ON [Products] ([CategoryID])
CREATE INDEX [CategoryID] ON [Products] ([CategoryID])

-- inserting into Products
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Chai', 1, 1, '10 boxes x 20 bags', '$18.00', 39, 0, 10, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Chang', 1, 1, '24 - 12 oz bottles', '$19.00', 17, 40, 25, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Aniseed Syrup', 1, 2, '12 - 550 ml bottles', '$10.00', 13, 70, 25, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Chef Anton''s Cajun Seasoning', 2, 2, '48 - 6 oz jars', '$22.00', 53, 0, 0, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Chef Anton''s Gumbo Mix', 2, 2, '36 boxes', '$21.35', 0, 0, 0, -1)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Grandma''s Boysenberry Spread', 3, 2, '12 - 8 oz jars', '$25.00', 120, 0, 25, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Uncle Bob''s Organic Dried Pears', 3, 7, '12 - 1 lb pkgs.', '$30.00', 15, 0, 10, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Northwoods Cranberry Sauce', 3, 2, '12 - 12 oz jars', '$40.00', 6, 0, 0, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Mishi Kobe Niku', 4, 6, '18 - 500 g pkgs.', '$97.00', 29, 0, 0, -1)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Ikura', 4, 8, '12 - 200 ml jars', '$31.00', 31, 0, 0, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Queso Cabrales', 5, 4, '1 kg pkg.', '$21.00', 22, 30, 30, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Queso Manchego La Pastora', 5, 4, '10 - 500 g pkgs.', '$38.00', 86, 0, 0, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Konbu', 6, 8, '2 kg box', '$6.00', 24, 0, 5, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Tofu', 6, 7, '40 - 100 g pkgs.', '$23.25', 35, 0, 0, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Genen Shouyu', 6, 2, '24 - 250 ml bottles', '$15.50', 39, 0, 5, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Pavlova', 7, 3, '32 - 500 g boxes', '$17.45', 29, 0, 10, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Alice Mutton', 7, 6, '20 - 1 kg tins', '$39.00', 0, 0, 0, -1)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Carnarvon Tigers', 7, 8, '16 kg pkg.', '$62.50', 42, 0, 0, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Teatime Chocolate Biscuits', 8, 3, '10 boxes x 12 pieces', '$9.20', 25, 0, 5, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Sir Rodney''s Marmalade', 8, 3, '30 gift boxes', '$81.00', 40, 0, 0, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Sir Rodney''s Scones', 8, 3, '24 pkgs. x 4 pieces', '$10.00', 3, 40, 5, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Gustaf''s Knäckebröd', 9, 5, '24 - 500 g pkgs.', '$21.00', 104, 0, 25, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Tunnbröd', 9, 5, '12 - 250 g pkgs.', '$9.00', 61, 0, 25, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Guaraná Fantástica', 10, 1, '12 - 355 ml cans', '$4.50', 20, 0, 0, -1)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('NuNuCa Nuß-Nougat-Creme', 11, 3, '20 - 450 g glasses', '$14.00', 76, 0, 30, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Gumbär Gummibärchen', 11, 3, '100 - 250 g bags', '$31.23', 15, 0, 0, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Schoggi Schokolade', 11, 3, '100 - 100 g pieces', '$43.90', 49, 0, 30, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Rössle Sauerkraut', 12, 7, '25 - 825 g cans', '$45.60', 26, 0, 0, -1)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Thüringer Rostbratwurst', 12, 6, '50 bags x 30 sausgs.', '$123.79', 0, 0, 0, -1)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Nord-Ost Matjeshering', 13, 8, '10 - 200 g glasses', '$25.89', 10, 0, 15, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Gorgonzola Telino', 14, 4, '12 - 100 g pkgs', '$12.50', 0, 70, 20, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Mascarpone Fabioli', 14, 4, '24 - 200 g pkgs.', '$32.00', 9, 40, 25, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Geitost', 15, 4, '500 g', '$2.50', 112, 0, 20, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Sasquatch Ale', 16, 1, '24 - 12 oz bottles', '$14.00', 111, 0, 15, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Steeleye Stout', 16, 1, '24 - 12 oz bottles', '$18.00', 20, 0, 15, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Inlagd Sill', 17, 8, '24 - 250 g  jars', '$19.00', 112, 0, 20, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Gravad lax', 17, 8, '12 - 500 g pkgs.', '$26.00', 11, 50, 25, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Côte de Blaye', 18, 1, '12 - 75 cl bottles', '$263.50', 17, 0, 15, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Chartreuse verte', 18, 1, '750 cc per bottle', '$18.00', 69, 0, 5, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Boston Crab Meat', 19, 8, '24 - 4 oz tins', '$18.40', 123, 0, 30, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Jack''s New England Clam Chowder', 19, 8, '12 - 12 oz cans', '$9.65', 85, 0, 10, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Singaporean Hokkien Fried Mee', 20, 5, '32 - 1 kg pkgs.', '$14.00', 26, 0, 0, -1)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Ipoh Coffee', 20, 1, '16 - 500 g tins', '$46.00', 17, 10, 25, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Gula Malacca', 20, 2, '20 - 2 kg bags', '$19.45', 27, 0, 15, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Røgede sild', 21, 8, '1k pkg.', '$9.50', 5, 70, 15, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Spegesild', 21, 8, '4 - 450 g glasses', '$12.00', 95, 0, 0, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Zaanse koeken', 22, 3, '10 - 4 oz boxes', '$9.50', 36, 0, 0, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Chocolade', 22, 3, '10 pkgs.', '$12.75', 15, 70, 25, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Maxilaku', 23, 3, '24 - 50 g pkgs.', '$20.00', 10, 60, 15, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Valkoinen suklaa', 23, 3, '12 - 100 g bars', '$16.25', 65, 0, 30, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Manjimup Dried Apples', 24, 7, '50 - 300 g pkgs.', '$53.00', 20, 0, 10, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Filo Mix', 24, 5, '16 - 2 kg boxes', '$7.00', 38, 0, 25, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Perth Pasties', 24, 6, '48 pieces', '$32.80', 0, 0, 0, -1)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Tourtière', 25, 6, '16 pies', '$7.45', 21, 0, 10, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Pâté chinois', 25, 6, '24 boxes x 2 pies', '$24.00', 115, 0, 20, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Gnocchi di nonna Alice', 26, 5, '24 - 250 g pkgs.', '$38.00', 21, 10, 30, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Ravioli Angelo', 26, 5, '24 - 250 g pkgs.', '$19.50', 36, 0, 20, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Escargots de Bourgogne', 27, 8, '24 pieces', '$13.25', 62, 0, 20, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Raclette Courdavault', 28, 4, '5 kg pkg.', '$55.00', 79, 0, 0, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Camembert Pierrot', 28, 4, '15 - 300 g rounds', '$34.00', 19, 0, 0, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Sirop d''érable', 29, 2, '24 - 500 ml bottles', '$28.50', 113, 0, 25, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Tarte au sucre', 29, 3, '48 pies', '$49.30', 17, 0, 0, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Vegie-spread', 7, 2, '15 - 625 g jars', '$43.90', 24, 0, 5, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Wimmers gute Semmelknödel', 12, 5, '20 bags x 4 pieces', '$33.25', 22, 80, 30, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Louisiana Fiery Hot Pepper Sauce', 2, 2, '32 - 8 oz bottles', '$21.05', 76, 0, 0, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Louisiana Hot Spiced Okra', 2, 2, '24 - 8 oz jars', '$17.00', 4, 100, 20, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Laughing Lumberjack Lager', 16, 1, '24 - 12 oz bottles', '$14.00', 52, 0, 10, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Scottish Longbreads', 8, 3, '10 boxes x 8 pieces', '$12.50', 6, 10, 15, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Gudbrandsdalsost', 15, 4, '10 kg pkg.', '$36.00', 26, 0, 15, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Outback Lager', 7, 1, '24 - 355 ml bottles', '$15.00', 15, 10, 30, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Fløtemysost', 15, 4, '10 - 500 g pkgs.', '$21.50', 26, 0, 0, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Mozzarella di Giovanni', 14, 4, '24 - 200 g pkgs.', '$34.80', 14, 0, 0, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Röd Kaviar', 17, 8, '24 - 150 g jars', '$15.00', 101, 0, 5, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Longlife Tofu', 4, 7, '5 kg pkg.', '$10.00', 4, 20, 5, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Rhönbräu Klosterbier', 12, 1, '24 - 0.5 l bottles', '$7.75', 125, 0, 25, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Lakkalikööri', 23, 1, '500 ml', '$18.00', 57, 0, 20, 0)
INSERT [Products]([ProductName], [SupplierID], [CategoryID], [QuantityPerUnit], [UnitPrice], [UnitsInStock], [UnitsOnOrder], [ReorderLevel], [Discontinued]) VALUES('Original Frankfurter grüne Soße', 12, 2, '12 boxes', '$13.00', 32, 0, 15, 0)
-- insert complete (77 rows)

-- end